1 <?php
2     include_once
'header.php';
3     ?>
4
5 <style>
6
7         body{
8                 background-image: url(
"images/cancel.jpg");
9                 background-repeat: no-repeat;
10                 background-size:
100%;
11                 color: white;
12             }
13 </style>
14 <body style=
"background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
15
16     <?php
17
18             $dbServername =
"localhost";
19             $dbUsername =
"root";
20             $dbPassword =
"password";
21             $dbName =
"test";
22             $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
23             
24             
25             $sql=
"call adding ('".$_SESSION['show_id']."','".$_SESSION['seats']."')";
26             mysqli_query($conn, $sql) or die(
'Error delete');
27             
28             $sql1=
"SELECT booking_id from booking ORDER BY booking_id desc LIMIT 1";
29             $result1=mysqli_query($conn,$sql1) or die(
"error delete 1");
30             $row=mysqli_fetch_array($result1);
31             
32
33             $sql2=
"delete from booking where booking_id='".$row['booking_id']."'";
34             $result2=mysqli_query($conn,$sql2) or die(
"error delete 2");
35             
36             $id=(
int)$row['booking_id'];
37             
38             
39             $sql3=
"ALTER TABLE booking AUTO_INCREMENT=$id";
40             mysqli_query($conn, $sql3) or die(
'Error auto_inc');
41
42             echo
'<center><p style="font-family: monospace; font-size:400%;"><br><b>Tickets Cancelled!</b><p></center>';
43
44
45         
46             unset($_SESSION[
'seats']);
47             unset($_SESSION[
'show_id']);
48
49     ?>
50
51
52
53
54 </body>
55
56 <?php
57     include_once
'footer.php';
58 ?>


Gõ tìm kiếm nhanh...